package com.jkoss.dao.jy;

import com.jkoss.pojo.jy.Jiuyerecode;
import com.jkoss.pojo.jy.JiuyerecodeExample;
import com.jkoss.tool.Page;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

public interface JiuyerecodeMapper {
	
	@Select("select a.* ,b.ename,c.stuname,c.stuphone from t_jiuyerecode a ,t_emps b ,t_ossstu c "
			+ "where a.ossstuid = c.ossstuid "
			+ "and a.eid = b.eid and jysuccid=#{jysuccid}")
	@ResultMap("com.jkoss.dao.jy.JiuyerecodeMapper.BaseResultMap2")
	Jiuyerecode findJyrecodeByID(Integer jysuccid);
	
	@Select("select a.* ,b.ename,c.stuname,c.stuphone from t_jiuyerecode a ,t_emps b ,t_ossstu c "
			+ "where a.ossstuid = c.ossstuid "
			+ "and a.eid = b.eid")
	@ResultMap("com.jkoss.dao.jy.JiuyerecodeMapper.BaseResultMap2")
	List<Jiuyerecode> listPageJyrecodes(Page<Jiuyerecode> page);
	
    int countByExample(JiuyerecodeExample example);

    int deleteByExample(JiuyerecodeExample example);

    int deleteByPrimaryKey(Integer jysuccid);

    int insert(Jiuyerecode record);

    int insertSelective(Jiuyerecode record);

    List<Jiuyerecode> selectByExample(JiuyerecodeExample example);

    Jiuyerecode selectByPrimaryKey(Integer jysuccid);

    int updateByExampleSelective(@Param("record") Jiuyerecode record, @Param("example") JiuyerecodeExample example);

    int updateByExample(@Param("record") Jiuyerecode record, @Param("example") JiuyerecodeExample example);

    int updateByPrimaryKeySelective(Jiuyerecode record);

    int updateByPrimaryKey(Jiuyerecode record);
}